package com.testmanager.testmananger.shuiyou.strCompare.respository;

import com.testmanager.testmananger.shuiyou.strCompare.domain.SySqlCompareScriptEntity;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.JpaSpecificationExecutor;
import org.springframework.data.jpa.repository.Modifying;
import org.springframework.data.querydsl.QuerydslPredicateExecutor;
import org.springframework.stereotype.Repository;

@Repository
public interface SySqlCompareRepository extends JpaRepository<SySqlCompareScriptEntity,Long>, JpaSpecificationExecutor<SySqlCompareScriptEntity>
        , QuerydslPredicateExecutor<SySqlCompareScriptEntity> {
    SySqlCompareScriptEntity findById(long scriptid);

    SySqlCompareScriptEntity findByScriptno(String scriptno);

    @Modifying
    Integer  deleteAllByScriptno(String scriptno);
}
